﻿<!DOCTYPE html>
<html>
	<head>
		<title>OFFSET Function</title>
		<meta charset="utf-8" />
		<meta name="description" content="" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>OFFSET Function</h1>
			<p>The <b>OFFSET</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to return a reference to a cell displaced from the specified cell (or the upper-left cell in the range of cells) to a certain number of rows and columns.</p>
			<h3>Syntax</h3> 
			<p><b><em>OFFSET(reference, rows, cols, [height], [width])</em></b></p> 
			<p>The <b>OFFSET</b> function has the following arguments:</p> 
			<table style="width: 40%">
                <tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>reference</em></b></td>
                    <td>A reference to an initial cell or range of cells.</td>
                </tr>
				<tr>
                    <td><b><em>rows</em></b></td>
                    <td>A number of rows, up or down, that you want the upper-left cell in the returned reference to refer to. Positive numbers mean the result will shift below the initial cell. Negative values mean it will shift above the initial cell.</td>
                </tr>
				<tr>
                    <td><b><em>cols</em></b></td>
                    <td>A number of columns, to the left or right, that you want the upper-left cell in the returned reference to refer to. Positive numbers mean the result will shift to the right of the initial cell. Negative values mean it will shift to the left of the initial cell.</td>
                </tr>
				<tr>
                    <td><b><em>height</em></b></td>
                    <td>A number of rows in the returned reference. The value must be a positive number. It's an optional argument. If it is omitted, the function will assume it to be equal to the initial range height.</td>
                </tr>
				<tr>
                    <td><b><em>width</em></b></td>
                    <td>A number of columns in the returned reference. The value must be a positive number. It's an optional argument. If it is omitted, the function will assume it to be equal to the initial range width.</td>
                </tr>
            </table>
			
			<h3>Notes</h3>
            <p>Please note that this is an array formula. To learn more, please read the <a href="../UsageInstructions/InsertArrayFormulas.htm" onclick="onhyperlinkclick(this)">Insert array formulas</a> article.</p>
            <p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>OFFSET</b> function.</p>
			
			<h3>Examples</h3>
            <p>The figure below displays the result returned by the <b>OFFSET</b> function.</p>
			<p><img alt="OFFSET Function" src="../images/offset.png" /></p>
		</div>
	</body>
</html>